Computer Science for IGCSE & O level - Databases (Section 5 - No. 19)
What does the `ON DELETE CASCADE` constraint do in a foreign key relationship?
Prevents the deletion of parent records.
Automatically deletes related child records when a parent record is deleted.
Updates the primary key of the child table when the parent key changes.
Allows the deletion of parent records but leaves the child records untouched.
Paliwanag
`ON DELETE CASCADE` automatically deletes related child records if the corresponding parent record is deleted.